Temporal SOLAP: Query Language, Implementation, and a Use Case
نویسندگان
چکیده
The integration of Geographic Information Systems (GIS) and On-Line Analytical Processing (OLAP), denoted SOLAP, is aimed at exploring and analyzing spatial data. In real-world SOLAP applications, spatial and non-spatial data are subject to changes. In this paper we present a temporal query language for SOLAP, called TPiet-QL, supporting so-called discrete changes (for example, in land use or cadastral applications there are situations where parcels are merged or split). TPiet-QL allows expressing integrated GIS-OLAP queries in an scenario where spatial objects change across time. We also present a prototype implementation, and show how this application is used in a real-world scenario: the analysis of protected areas in Uruguay.
منابع مشابه
A Taxonomy of SOLAP Operators
Different proposals of SOLAP query languages exist in the literature; however, a taxonomy of SOLAP operators has not been formally defined to date. This paper presents a systematic method for classifying SOLAP operators which combines the elements that constitute a data cube with three application categories: multidimensional, spatial and temporal. Additionally, this paper proposes a set of SOL...
متن کاملTowards Spatio-Temporal SOLAP
The integration of Geographic Information Systems (GIS) and On-Line Analytical Processing (OLAP), denoted SOLAP, is aimed at exploring and analyzing spatial data. In real-world SOLAP applications, spatial and non-spatial data are subject to changes. In this paper we present a temporal query language for SOLAP, called TPiet-QL, supporting so-called discrete changes (for example, in land use or c...
متن کاملQuerying Geographical Data Warehouses With GeoMDQL
Integrating geographical and multidimensional processing has been proposed in several researches in the database literature. One of the most important issues of this process is data querying. However, most of the current approaches do not take into account the use of a query language to make the simultaneous specification of multidimensional and spatial operators available. In this paper, we pr...
متن کاملانتخاب مناسبترین زبان پرسوجو برای استفاده از فراپیوندها جهت استخراج دادهها در حالت دیتالوگ در سامانه پایگاه داده استنتاجی DES
Deductive Database systems are designed based on a logical data model. Data (as opposed to Relational Databases Management System (RDBMS) in which data stored in tables) are saved as facts in a Deductive Database system. Datalog Educational System (DES) is a Deductive Database system that Datalog mode is the default mode in this system. It can extract data to use outer joins with three query la...
متن کاملDevelopment of A SOLAP Patrimony Management Application System: Fez Medina as a Case Study
It is well known that transactional and analytical systems each require different database architecture. In general, the database structure of transactional systems is optimized for consistency and efficient updates while the database structure for decision-support systems is optimized for complex query analysis and key performance indicators reporting. Spatial data has also become an important...
متن کامل